Use this dialog box to define the currency format.
| Field | Description |
|---|
| Type
|
Select the currency type:
- Percent - Percent fields always have the percent symbol following the number. This option is only visible for normal number fields.
- Number - This option is visible for normal number fields.
- Currency - This option is visible for currency fields.
|
| Apply To
|
Specify if the currency type applies to all fields or this column only.
|
| Decimal Places
|
Decimal place options are the numbers 0 through 9. The number selected controls how many decimal places are displayed for the number. For example, if you selected 2, then one thousand would be displayed as 1000.00.
Some fields do not use the decimal settings that you select because the number of decimal places is hard-coded into the report. Examples of these fields include:
- Hours - Most hour fields have two decimal places.
- Rates - Most rate fields have four decimal places.
- Places where decimals are not appropriate - Some fields do not have any decimal places because only whole numbers are appropriate values in those fields.
|
| Digit Grouping
|
From this drop-down list you can select how the numbers are grouped. The digit grouping options are:
- 123,456,789 - The number is always grouped by three digits.
- 12,34,56,789 - The last grouping has three digits, but all others have two.
- 123456789 - There is no digit grouping.
|
| Currency Symbol
|
Select the symbol for the currency.
|
| Negative Number
|
Negative number options in this drop-down list are:
- Parentheses - The number is surrounded by parentheses (1,000, for example).
- Sign on Front - The negative sign displays before the number (-1,000, for example).
- Sign on Back - The negative sign displays after the number (1,000-, for example).
|
| Zero Number
|
Zero number options in this drop-down list are:
- 0 - Zero values are represented by a 0.
- - - Zero values are represented by a dash. If you select this option, then it should be centered on the report so that it is not confused with a negative sign.
- Do not display - Zero values are represented by a blank.
|
| Symbol Location
|
Specify where the currency symbol displays in relation to the number.
|
| Sample
|
This group box displays a sample of the positive number, negative number, and zero formats. The number 123,456,789.00 is used for the positive and negative numbers. The currency symbol displays, if applicable.
|
